Overview
Dataset statistics
| Number of variables | 28 |
|---|---|
| Number of observations | 507 |
| Missing cells | 6062 |
| Missing cells (%) | 42.7% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 98.2 KiB |
| Average record size in memory | 198.3 B |
Variable types
| Categorical | 12 |
|---|---|
| Numeric | 5 |
| Unsupported | 4 |
| Text | 5 |
| Boolean | 2 |
HEAD_OFFICE_ID has constant value "2" | Constant |
REC_TYPE has constant value "U" | Constant |
CIN_EXT_SALES_ID has constant value "" | Constant |
CRNCY_ID has constant value "1.0" | Constant |
CIN_CRNCY has constant value "1" | Constant |
CIN_CRCY_REG has constant value "" | Constant |
CIN_EMAIL has constant value "" | Constant |
CIN_IS_DEL has constant value "False" | Constant |
CCT_ID is highly overall correlated with CIN_ACCT_CODE and 3 other fields | High correlation |
CIN_ACCT_CODE is highly overall correlated with CCT_ID and 2 other fields | High correlation |
CIN_GL_CODE is highly overall correlated with CCT_ID and 2 other fields | High correlation |
CIN_GST_CODE is highly overall correlated with SRC_DB_ID and 1 other fields | High correlation |
CIN_ID is highly overall correlated with SRC_DB_ID and 1 other fields | High correlation |
CIN_IS_ACTV is highly overall correlated with CIN_STATUS_CODE and 2 other fields | High correlation |
CIN_STATUS_CODE is highly overall correlated with CIN_IS_ACTV and 2 other fields | High correlation |
CIN_TYPE_ID is highly overall correlated with CIN_GL_CODE and 1 other fields | High correlation |
SITE_ID is highly overall correlated with SRC_TYPE_ID | High correlation |
SRC_DB_ID is highly overall correlated with CCT_ID and 6 other fields | High correlation |
SRC_TYPE_ID is highly overall correlated with CCT_ID and 9 other fields | High correlation |
CIN_STATUS_CODE is highly imbalanced (52.0%) | Imbalance |
CCT_ID is highly imbalanced (65.5%) | Imbalance |
CIN_ACCT_CODE is highly imbalanced (76.1%) | Imbalance |
REC_TYPE has 280 (55.2%) missing values | Missing |
CIN_EXT_SALES_ID has 227 (44.8%) missing values | Missing |
CIN_GRP_ID has 507 (100.0%) missing values | Missing |
CIN_STATUS_CODE has 227 (44.8%) missing values | Missing |
CIN_TYPE_ID has 227 (44.8%) missing values | Missing |
CCT_ID has 227 (44.8%) missing values | Missing |
CRNCY_ID has 227 (44.8%) missing values | Missing |
SITE_ID has 227 (44.8%) missing values | Missing |
CINEMA has 227 (44.8%) missing values | Missing |
CIN_ACCT_CODE has 227 (44.8%) missing values | Missing |
CIN_CODE has 6 (1.2%) missing values | Missing |
CIN_CRNCY has 227 (44.8%) missing values | Missing |
CIN_CRCY_REG has 227 (44.8%) missing values | Missing |
CIN_EMAIL has 363 (71.6%) missing values | Missing |
CIN_GL_CODE has 227 (44.8%) missing values | Missing |
CIN_GRP_CODE has 507 (100.0%) missing values | Missing |
CIN_GST_CODE has 227 (44.8%) missing values | Missing |
CIN_HO_CODE has 102 (20.1%) missing values | Missing |
CIN_IS_ACTV has 166 (32.7%) missing values | Missing |
CIN_IS_DEL has 166 (32.7%) missing values | Missing |
CIN_LIC_ISSUE_DATE has 507 (100.0%) missing values | Missing |
CIN_LIC_NO has 507 (100.0%) missing values | Missing |
CIN_NAME_SHORT has 227 (44.8%) missing values | Missing |
CIN_ID has unique values | Unique |
TIMESTAMP has unique values | Unique |
CIN_GRP_ID is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
CIN_GRP_CODE is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
CIN_LIC_ISSUE_DATE is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
CIN_LIC_NO is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2025-12-18 06:28:20.416855 |
|---|---|
| Analysis finished | 2025-12-18 06:28:22.271781 |
| Duration | 1.85 second |
| Software version | ydata-profiling vv4.18.0 |
| Download configuration | config.json |
Variables
HEAD_OFFICE_ID
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 KiB |
| 2 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 2 |
| 3rd row | 2 |
| 4th row | 2 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 507 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2 | 507 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 507 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 507 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 507 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 507 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 507 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 507 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 507 |
REC_TYPE
Categorical
Constant Missing
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 280 |
| Missing (%) | 55.2% |
| Memory size | 4.1 KiB |
| U |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | U |
|---|---|
| 2nd row | U |
| 3rd row | U |
| 4th row | U |
| 5th row | U |
Common Values
| Value | Count | Frequency (%) |
| U | 227 | |
| (Missing) | 280 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| u | 227 |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 227 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 227 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| U | 227 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 227 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| U | 227 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 227 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| U | 227 |
SRC_DB_ID
Real number (ℝ)
High correlation
| Distinct | 95 |
|---|---|
| Distinct (%) | 18.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 90.280079 |
| Minimum | 3 |
|---|---|
| Maximum | 1102 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 4 |
| median | 4 |
| Q3 | 68 |
| 95-th percentile | 1074.7 |
| Maximum | 1102 |
| Range | 1099 |
| Interquartile range (IQR) | 64 |
Descriptive statistics
| Standard deviation | 255.64568 |
|---|---|
| Coefficient of variation (CV) | 2.8316954 |
| Kurtosis | 11.215068 |
| Mean | 90.280079 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.6023158 |
| Sum | 45772 |
| Variance | 65354.716 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 280 | |
| 68 | 125 | |
| 38 | 2 | 0.4% |
| 17 | 2 | 0.4% |
| 16 | 2 | 0.4% |
| 64 | 2 | 0.4% |
| 15 | 2 | 0.4% |
| 44 | 2 | 0.4% |
| 66 | 2 | 0.4% |
| 11 | 2 | 0.4% |
| Other values (85) | 86 | 17.0% |
| Value | Count | Frequency (%) |
| 3 | 1 | 0.2% |
| 4 | 280 | |
| 5 | 1 | 0.2% |
| 6 | 1 | 0.2% |
| 7 | 1 | 0.2% |
| 8 | 1 | 0.2% |
| 9 | 1 | 0.2% |
| 10 | 1 | 0.2% |
| 11 | 2 | 0.4% |
| 12 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 1102 | 1 | |
| 1100 | 1 | |
| 1099 | 1 | |
| 1097 | 1 | |
| 1096 | 1 | |
| 1095 | 1 | |
| 1094 | 1 | |
| 1093 | 1 | |
| 1092 | 1 | |
| 1091 | 1 |
SRC_TYPE_ID
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 KiB |
| 1 | |
|---|---|
| 3 | |
| 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 280 | |
| 3 | 125 | |
| 2 | 102 | 20.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 280 | |
| 3 | 125 | |
| 2 | 102 | 20.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 280 | |
| 3 | 125 | |
| 2 | 102 | 20.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 507 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 280 | |
| 3 | 125 | |
| 2 | 102 | 20.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 507 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 280 | |
| 3 | 125 | |
| 2 | 102 | 20.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 507 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 280 | |
| 3 | 125 | |
| 2 | 102 | 20.1% |
CIN_ID
Real number (ℝ)
High correlation Unique
| Distinct | 507 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4477.8777 |
| Minimum | 3 |
|---|---|
| Maximum | 10803 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 28.3 |
| Q1 | 129.5 |
| median | 262 |
| Q3 | 10670.5 |
| 95-th percentile | 10771.7 |
| Maximum | 10803 |
| Range | 10800 |
| Interquartile range (IQR) | 10541 |
Descriptive statistics
| Standard deviation | 5190.1118 |
|---|---|
| Coefficient of variation (CV) | 1.1590562 |
| Kurtosis | -1.8727723 |
| Mean | 4477.8777 |
| Median Absolute Deviation (MAD) | 214 |
| Skewness | 0.36562828 |
| Sum | 2270284 |
| Variance | 26937260 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 1 | 0.2% |
| 7 | 1 | 0.2% |
| 11 | 1 | 0.2% |
| 15 | 1 | 0.2% |
| 19 | 1 | 0.2% |
| 23 | 1 | 0.2% |
| 27 | 1 | 0.2% |
| 31 | 1 | 0.2% |
| 35 | 1 | 0.2% |
| 39 | 1 | 0.2% |
| Other values (497) | 497 |
| Value | Count | Frequency (%) |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 | |
| 11 | 1 | |
| 12 | 1 |
| Value | Count | Frequency (%) |
| 10803 | 1 | |
| 10801 | 1 | |
| 10800 | 1 | |
| 10799 | 1 | |
| 10798 | 1 | |
| 10797 | 1 | |
| 10795 | 1 | |
| 10794 | 1 | |
| 10793 | 1 | |
| 10791 | 1 |
CIN_EXT_SALES_ID
Categorical
Constant Missing
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 227 |
| Missing (%) | 44.8% |
| Memory size | 4.1 KiB |
Length
| Max length | 0 |
|---|---|
| Median length | 0 |
| Mean length | 0 |
| Min length | 0 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | |
|---|---|
| 2nd row | |
| 3rd row | |
| 4th row | |
| 5th row |
Common Values
| Value | Count | Frequency (%) |
| 280 | ||
| (Missing) | 227 |
Length
Common Values (Plot)
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
CIN_GRP_ID
Unsupported
Missing Rejected Unsupported
| Missing | 507 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 4.1 KiB |
CIN_STATUS_CODE
Categorical
High correlation Imbalance Missing
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 227 |
| Missing (%) | 44.8% |
| Memory size | 4.1 KiB |
| A | |
|---|---|
| I |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A |
|---|---|
| 2nd row | A |
| 3rd row | A |
| 4th row | I |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| A | 251 | |
| I | 29 | 5.7% |
| (Missing) | 227 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| a | 251 | |
| i | 29 | 10.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 251 | |
| I | 29 | 10.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 280 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 251 | |
| I | 29 | 10.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 280 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 251 | |
| I | 29 | 10.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 280 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 251 | |
| I | 29 | 10.4% |
CIN_TYPE_ID
Real number (ℝ)
High correlation Missing
| Distinct | 13 |
|---|---|
| Distinct (%) | 4.6% |
| Missing | 227 |
| Missing (%) | 44.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.3964286 |
| Minimum | 1 |
|---|---|
| Maximum | 15 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 6 |
| Q3 | 10 |
| 95-th percentile | 11 |
| Maximum | 15 |
| Range | 14 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 4.1135306 |
|---|---|
| Coefficient of variation (CV) | 0.76226908 |
| Kurtosis | -1.2419639 |
| Mean | 5.3964286 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.32233088 |
| Sum | 1511 |
| Variance | 16.921134 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 105 | |
| 6 | 52 | 10.3% |
| 11 | 46 | 9.1% |
| 7 | 28 | 5.5% |
| 10 | 13 | 2.6% |
| 5 | 7 | 1.4% |
| 2 | 7 | 1.4% |
| 8 | 5 | 1.0% |
| 3 | 5 | 1.0% |
| 12 | 4 | 0.8% |
| Other values (3) | 8 | 1.6% |
| (Missing) | 227 |
| Value | Count | Frequency (%) |
| 1 | 105 | |
| 2 | 7 | 1.4% |
| 3 | 5 | 1.0% |
| 5 | 7 | 1.4% |
| 6 | 52 | |
| 7 | 28 | 5.5% |
| 8 | 5 | 1.0% |
| 10 | 13 | 2.6% |
| 11 | 46 | |
| 12 | 4 | 0.8% |
| Value | Count | Frequency (%) |
| 15 | 1 | 0.2% |
| 14 | 4 | 0.8% |
| 13 | 3 | 0.6% |
| 12 | 4 | 0.8% |
| 11 | 46 | |
| 10 | 13 | 2.6% |
| 8 | 5 | 1.0% |
| 7 | 28 | |
| 6 | 52 | |
| 5 | 7 | 1.4% |
CCT_ID
Categorical
High correlation Imbalance Missing
| Distinct | 5 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 227 |
| Missing (%) | 44.8% |
| Memory size | 4.1 KiB |
| 177.0 | |
|---|---|
| 178.0 | |
| 1178.0 | 7 |
| 1179.0 | 2 |
| 1180.0 | 1 |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 5.0357143 |
| Min length | 5 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 1180.0 |
|---|---|
| 2nd row | 177.0 |
| 3rd row | 177.0 |
| 4th row | 177.0 |
| 5th row | 177.0 |
Common Values
| Value | Count | Frequency (%) |
| 177.0 | 235 | |
| 178.0 | 35 | 6.9% |
| 1178.0 | 7 | 1.4% |
| 1179.0 | 2 | 0.4% |
| 1180.0 | 1 | 0.2% |
| (Missing) | 227 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 177.0 | 235 | |
| 178.0 | 35 | 12.5% |
| 1178.0 | 7 | 2.5% |
| 1179.0 | 2 | 0.7% |
| 1180.0 | 1 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 7 | 514 | |
| 1 | 290 | |
| 0 | 281 | |
| . | 280 | |
| 8 | 43 | 3.0% |
| 9 | 2 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1410 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 7 | 514 | |
| 1 | 290 | |
| 0 | 281 | |
| . | 280 | |
| 8 | 43 | 3.0% |
| 9 | 2 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1410 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 7 | 514 | |
| 1 | 290 | |
| 0 | 281 | |
| . | 280 | |
| 8 | 43 | 3.0% |
| 9 | 2 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1410 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 7 | 514 | |
| 1 | 290 | |
| 0 | 281 | |
| . | 280 | |
| 8 | 43 | 3.0% |
| 9 | 2 | 0.1% |
CRNCY_ID
Categorical
Constant Missing
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 227 |
| Missing (%) | 44.8% |
| Memory size | 4.1 KiB |
| 1.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 280 | |
| (Missing) | 227 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 280 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 280 | |
| . | 280 | |
| 0 | 280 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 840 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 280 | |
| . | 280 | |
| 0 | 280 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 840 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 280 | |
| . | 280 | |
| 0 | 280 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 840 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 280 | |
| . | 280 | |
| 0 | 280 |
SITE_ID
Real number (ℝ)
High correlation Missing
| Distinct | 105 |
|---|---|
| Distinct (%) | 37.5% |
| Missing | 227 |
| Missing (%) | 44.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 204.83571 |
| Minimum | 2 |
|---|---|
| Maximum | 7318 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 21.75 |
| median | 47.5 |
| Q3 | 76 |
| 95-th percentile | 101 |
| Maximum | 7318 |
| Range | 7316 |
| Interquartile range (IQR) | 54.25 |
Descriptive statistics
| Standard deviation | 1054.0644 |
|---|---|
| Coefficient of variation (CV) | 5.1459013 |
| Kurtosis | 42.387921 |
| Mean | 204.83571 |
| Median Absolute Deviation (MAD) | 26.5 |
| Skewness | 6.6366174 |
| Sum | 57354 |
| Variance | 1111051.7 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14 | 8 | 1.6% |
| 69 | 8 | 1.6% |
| 16 | 8 | 1.6% |
| 80 | 7 | 1.4% |
| 22 | 7 | 1.4% |
| 59 | 7 | 1.4% |
| 23 | 6 | 1.2% |
| 21 | 6 | 1.2% |
| 15 | 6 | 1.2% |
| 41 | 5 | 1.0% |
| Other values (95) | 212 | |
| (Missing) | 227 |
| Value | Count | Frequency (%) |
| 2 | 2 | 0.4% |
| 3 | 2 | 0.4% |
| 4 | 5 | |
| 5 | 1 | 0.2% |
| 6 | 1 | 0.2% |
| 7 | 2 | 0.4% |
| 8 | 3 | |
| 9 | 4 | |
| 10 | 2 | 0.4% |
| 11 | 5 |
| Value | Count | Frequency (%) |
| 7318 | 1 | 0.2% |
| 7317 | 2 | 0.4% |
| 7307 | 3 | |
| 124 | 3 | |
| 123 | 2 | 0.4% |
| 101 | 5 | |
| 100 | 1 | 0.2% |
| 99 | 5 | |
| 98 | 3 | |
| 97 | 3 |
CINEMA
Text
Missing
| Distinct | 280 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 227 |
| Missing (%) | 44.8% |
| Memory size | 4.1 KiB |
Length
| Max length | 30 |
|---|---|
| Median length | 23 |
| Mean length | 16.171429 |
| Min length | 5 |
Unique
| Unique | 280 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | State Theatre |
|---|---|
| 2nd row | George Street Cafe Bar |
| 3rd row | Parramatta Gold Class |
| 4th row | zInactive-Newcastle |
| 5th row | Hornsby |
| Value | Count | Frequency (%) |
| delivery | 54 | 9.0% |
| vmax | 46 | 7.7% |
| gold | 27 | 4.5% |
| class | 27 | 4.5% |
| cafe | 13 | 2.2% |
| bar | 13 | 2.2% |
| street | 11 | 1.8% |
| city | 10 | 1.7% |
| north | 8 | 1.3% |
| innaloo | 8 | 1.3% |
| Other values (142) | 380 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 427 | 9.4% |
| e | 409 | 9.0% |
| 317 | 7.0% | |
| l | 283 | 6.2% |
| o | 275 | 6.1% |
| r | 269 | 5.9% |
| i | 261 | 5.8% |
| n | 222 | 4.9% |
| t | 209 | 4.6% |
| s | 138 | 3.0% |
| Other values (46) | 1718 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4528 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 427 | 9.4% |
| e | 409 | 9.0% |
| 317 | 7.0% | |
| l | 283 | 6.2% |
| o | 275 | 6.1% |
| r | 269 | 5.9% |
| i | 261 | 5.8% |
| n | 222 | 4.9% |
| t | 209 | 4.6% |
| s | 138 | 3.0% |
| Other values (46) | 1718 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4528 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 427 | 9.4% |
| e | 409 | 9.0% |
| 317 | 7.0% | |
| l | 283 | 6.2% |
| o | 275 | 6.1% |
| r | 269 | 5.9% |
| i | 261 | 5.8% |
| n | 222 | 4.9% |
| t | 209 | 4.6% |
| s | 138 | 3.0% |
| Other values (46) | 1718 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4528 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 427 | 9.4% |
| e | 409 | 9.0% |
| 317 | 7.0% | |
| l | 283 | 6.2% |
| o | 275 | 6.1% |
| r | 269 | 5.9% |
| i | 261 | 5.8% |
| n | 222 | 4.9% |
| t | 209 | 4.6% |
| s | 138 | 3.0% |
| Other values (46) | 1718 |
CIN_ACCT_CODE
Categorical
High correlation Imbalance Missing
| Distinct | 38 |
|---|---|
| Distinct (%) | 13.6% |
| Missing | 227 |
| Missing (%) | 44.8% |
| Memory size | 4.1 KiB |
| 712915 | 1 |
|---|---|
| 718923 | 1 |
| 720920 | 1 |
| 724915 | 1 |
| Other values (33) |
Length
| Max length | 6 |
|---|---|
| Median length | 0 |
| Mean length | 0.79285714 |
| Min length | 0 |
Unique
| Unique | 37 ? |
|---|---|
| Unique (%) | 13.2% |
Sample
| 1st row | |
|---|---|
| 2nd row | |
| 3rd row | |
| 4th row | |
| 5th row |
Common Values
| Value | Count | Frequency (%) |
| 243 | ||
| 712915 | 1 | 0.2% |
| 718923 | 1 | 0.2% |
| 720920 | 1 | 0.2% |
| 724915 | 1 | 0.2% |
| 716915 | 1 | 0.2% |
| 733915 | 1 | 0.2% |
| 726915 | 1 | 0.2% |
| 710920 | 1 | 0.2% |
| 735913 | 1 | 0.2% |
| Other values (28) | 28 | 5.5% |
| (Missing) | 227 |
Length
| Value | Count | Frequency (%) |
| 712915 | 1 | 2.7% |
| 718923 | 1 | 2.7% |
| 720920 | 1 | 2.7% |
| 724915 | 1 | 2.7% |
| 716915 | 1 | 2.7% |
| 733915 | 1 | 2.7% |
| 726915 | 1 | 2.7% |
| 710920 | 1 | 2.7% |
| 735913 | 1 | 2.7% |
| 719923 | 1 | 2.7% |
| Other values (27) | 27 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 49 | |
| 9 | 41 | |
| 7 | 39 | |
| 5 | 32 | |
| 2 | 23 | |
| 3 | 14 | 6.3% |
| 0 | 12 | 5.4% |
| 6 | 5 | 2.3% |
| 8 | 4 | 1.8% |
| 4 | 3 | 1.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 222 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 49 | |
| 9 | 41 | |
| 7 | 39 | |
| 5 | 32 | |
| 2 | 23 | |
| 3 | 14 | 6.3% |
| 0 | 12 | 5.4% |
| 6 | 5 | 2.3% |
| 8 | 4 | 1.8% |
| 4 | 3 | 1.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 222 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 49 | |
| 9 | 41 | |
| 7 | 39 | |
| 5 | 32 | |
| 2 | 23 | |
| 3 | 14 | 6.3% |
| 0 | 12 | 5.4% |
| 6 | 5 | 2.3% |
| 8 | 4 | 1.8% |
| 4 | 3 | 1.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 222 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 49 | |
| 9 | 41 | |
| 7 | 39 | |
| 5 | 32 | |
| 2 | 23 | |
| 3 | 14 | 6.3% |
| 0 | 12 | 5.4% |
| 6 | 5 | 2.3% |
| 8 | 4 | 1.8% |
| 4 | 3 | 1.4% |
CIN_CODE
Text
Missing
| Distinct | 407 |
|---|---|
| Distinct (%) | 81.2% |
| Missing | 6 |
| Missing (%) | 1.2% |
| Memory size | 4.1 KiB |
Length
| Max length | 13 |
|---|---|
| Median length | 6 |
| Mean length | 6.0219561 |
| Min length | 2 |
Unique
| Unique | 404 ? |
|---|---|
| Unique (%) | 80.6% |
Sample
| 1st row | 102370 |
|---|---|
| 2nd row | 104918 |
| 3rd row | 107917 |
| 4th row | 111915 |
| 5th row | 117915 |
| Value | Count | Frequency (%) |
| 99 | 93 | 18.3% |
| gtscin | 5 | 1.0% |
| maqrie | 3 | 0.6% |
| gc | 3 | 0.6% |
| n'maqrie | 2 | 0.4% |
| cg | 2 | 0.4% |
| 474915 | 2 | 0.4% |
| 138917 | 2 | 0.4% |
| 102370 | 1 | 0.2% |
| n'411915 | 1 | 0.2% |
| Other values (395) | 395 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9 | 649 | |
| 1 | 477 | |
| 2 | 293 | |
| 4 | 271 | |
| 5 | 236 | 7.8% |
| ' | 228 | 7.6% |
| 0 | 197 | 6.5% |
| 7 | 191 | 6.3% |
| 3 | 141 | 4.7% |
| n | 117 | 3.9% |
| Other values (20) | 217 | 7.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3017 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 9 | 649 | |
| 1 | 477 | |
| 2 | 293 | |
| 4 | 271 | |
| 5 | 236 | 7.8% |
| ' | 228 | 7.6% |
| 0 | 197 | 6.5% |
| 7 | 191 | 6.3% |
| 3 | 141 | 4.7% |
| n | 117 | 3.9% |
| Other values (20) | 217 | 7.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3017 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 9 | 649 | |
| 1 | 477 | |
| 2 | 293 | |
| 4 | 271 | |
| 5 | 236 | 7.8% |
| ' | 228 | 7.6% |
| 0 | 197 | 6.5% |
| 7 | 191 | 6.3% |
| 3 | 141 | 4.7% |
| n | 117 | 3.9% |
| Other values (20) | 217 | 7.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3017 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 9 | 649 | |
| 1 | 477 | |
| 2 | 293 | |
| 4 | 271 | |
| 5 | 236 | 7.8% |
| ' | 228 | 7.6% |
| 0 | 197 | 6.5% |
| 7 | 191 | 6.3% |
| 3 | 141 | 4.7% |
| n | 117 | 3.9% |
| Other values (20) | 217 | 7.2% |
CIN_CRNCY
Categorical
Constant Missing
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 227 |
| Missing (%) | 44.8% |
| Memory size | 4.1 KiB |
| 1 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 280 | |
| (Missing) | 227 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 280 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 280 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 280 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 280 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 280 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 280 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 280 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 280 |
CIN_CRCY_REG
Categorical
Constant Missing
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 227 |
| Missing (%) | 44.8% |
| Memory size | 4.1 KiB |
Length
| Max length | 0 |
|---|---|
| Median length | 0 |
| Mean length | 0 |
| Min length | 0 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | |
|---|---|
| 2nd row | |
| 3rd row | |
| 4th row | |
| 5th row |
Common Values
| Value | Count | Frequency (%) |
| 280 | ||
| (Missing) | 227 |
Length
Common Values (Plot)
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
CIN_EMAIL
Categorical
Constant Missing
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 363 |
| Missing (%) | 71.6% |
| Memory size | 4.1 KiB |
Length
| Max length | 0 |
|---|---|
| Median length | 0 |
| Mean length | 0 |
| Min length | 0 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | |
|---|---|
| 2nd row | |
| 3rd row | |
| 4th row | |
| 5th row |
Common Values
| Value | Count | Frequency (%) |
| 144 | 28.4% | |
| (Missing) | 363 |
Length
Common Values (Plot)
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
CIN_GL_CODE
Real number (ℝ)
High correlation Missing
| Distinct | 15 |
|---|---|
| Distinct (%) | 5.4% |
| Missing | 227 |
| Missing (%) | 44.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 915.79643 |
| Minimum | 370 |
|---|---|
| Maximum | 927 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.1 KiB |
Quantile statistics
| Minimum | 370 |
|---|---|
| 5-th percentile | 915 |
| Q1 | 915 |
| median | 917 |
| Q3 | 920.25 |
| 95-th percentile | 922 |
| Maximum | 927 |
| Range | 557 |
| Interquartile range (IQR) | 5.25 |
Descriptive statistics
| Standard deviation | 32.881856 |
|---|---|
| Coefficient of variation (CV) | 0.035905203 |
| Kurtosis | 274.96048 |
| Mean | 915.79643 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -16.507026 |
| Sum | 256423 |
| Variance | 1081.2165 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 915 | 104 | |
| 922 | 56 | 11.0% |
| 918 | 47 | 9.3% |
| 917 | 26 | 5.1% |
| 919 | 13 | 2.6% |
| 914 | 7 | 1.4% |
| 923 | 5 | 1.0% |
| 913 | 5 | 1.0% |
| 916 | 4 | 0.8% |
| 926 | 4 | 0.8% |
| Other values (5) | 9 | 1.8% |
| (Missing) | 227 |
| Value | Count | Frequency (%) |
| 370 | 1 | 0.2% |
| 913 | 5 | 1.0% |
| 914 | 7 | 1.4% |
| 915 | 104 | |
| 916 | 4 | 0.8% |
| 917 | 26 | 5.1% |
| 918 | 47 | |
| 919 | 13 | 2.6% |
| 920 | 3 | 0.6% |
| 921 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 927 | 1 | 0.2% |
| 926 | 4 | 0.8% |
| 924 | 3 | 0.6% |
| 923 | 5 | 1.0% |
| 922 | 56 | |
| 921 | 1 | 0.2% |
| 920 | 3 | 0.6% |
| 919 | 13 | 2.6% |
| 918 | 47 | |
| 917 | 26 |
CIN_GRP_CODE
Unsupported
Missing Rejected Unsupported
| Missing | 507 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 4.1 KiB |
CIN_GST_CODE
Categorical
High correlation Missing
| Distinct | 14 |
|---|---|
| Distinct (%) | 5.0% |
| Missing | 227 |
| Missing (%) | 44.8% |
| Memory size | 4.1 KiB |
| ABN: 33 595 052 153 | |
|---|---|
| ABN: | |
| ABN: 40 009 659 643 | |
| ABN: 99 000 024 439 | |
| ABN: 11 913 370 633 | |
| Other values (9) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 15.210714 |
| Min length | 4 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | ABN: |
|---|---|
| 2nd row | ABN: 99 000 024 439 |
| 3rd row | ABN: 33 595 052 153 |
| 4th row | ABN: 99 000 024 439 |
| 5th row | ABN: 11 913 370 633 |
Common Values
| Value | Count | Frequency (%) |
| ABN: 33 595 052 153 | 84 | 16.6% |
| ABN: | 70 | 13.8% |
| ABN: 40 009 659 643 | 54 | 10.7% |
| ABN: 99 000 024 439 | 23 | 4.5% |
| ABN: 11 913 370 633 | 17 | 3.4% |
| ABN: 25 221 284 744 | 6 | 1.2% |
| ABN: 75 934 743 451 | 6 | 1.2% |
| ABN: 16 588 912 255 | 5 | 1.0% |
| ABN: 19 018 690 039 | 4 | 0.8% |
| ABN: 92 630 664 979 | 3 | 0.6% |
| Other values (4) | 8 | 1.6% |
| (Missing) | 227 |
Length
| Value | Count | Frequency (%) |
| abn | 279 | |
| 33 | 84 | 7.5% |
| 595 | 84 | 7.5% |
| 052 | 84 | 7.5% |
| 153 | 84 | 7.5% |
| 40 | 54 | 4.8% |
| 009 | 54 | 4.8% |
| 659 | 54 | 4.8% |
| 643 | 54 | 4.8% |
| 99 | 23 | 2.1% |
| Other values (39) | 260 |
Most occurring characters
| Value | Count | Frequency (%) |
| 834 | ||
| 3 | 431 | |
| 5 | 426 | |
| 0 | 385 | |
| 9 | 321 | 7.5% |
| : | 279 | 6.6% |
| B | 279 | 6.6% |
| N | 279 | 6.6% |
| A | 279 | 6.6% |
| 4 | 193 | 4.5% |
| Other values (6) | 553 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4259 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 834 | ||
| 3 | 431 | |
| 5 | 426 | |
| 0 | 385 | |
| 9 | 321 | 7.5% |
| : | 279 | 6.6% |
| B | 279 | 6.6% |
| N | 279 | 6.6% |
| A | 279 | 6.6% |
| 4 | 193 | 4.5% |
| Other values (6) | 553 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4259 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 834 | ||
| 3 | 431 | |
| 5 | 426 | |
| 0 | 385 | |
| 9 | 321 | 7.5% |
| : | 279 | 6.6% |
| B | 279 | 6.6% |
| N | 279 | 6.6% |
| A | 279 | 6.6% |
| 4 | 193 | 4.5% |
| Other values (6) | 553 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4259 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 834 | ||
| 3 | 431 | |
| 5 | 426 | |
| 0 | 385 | |
| 9 | 321 | 7.5% |
| : | 279 | 6.6% |
| B | 279 | 6.6% |
| N | 279 | 6.6% |
| A | 279 | 6.6% |
| 4 | 193 | 4.5% |
| Other values (6) | 553 |
CIN_HO_CODE
Text
Missing
| Distinct | 405 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 102 |
| Missing (%) | 20.1% |
| Memory size | 4.1 KiB |
Length
| Max length | 13 |
|---|---|
| Median length | 6 |
| Mean length | 6.9333333 |
| Min length | 4 |
Unique
| Unique | 405 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 102370 |
|---|---|
| 2nd row | 104918 |
| 3rd row | 107917 |
| 4th row | 111915 |
| 5th row | 117915 |
| Value | Count | Frequency (%) |
| gtscin | 4 | 1.0% |
| gc | 3 | 0.7% |
| maqrie | 3 | 0.7% |
| n'maqrie | 2 | 0.5% |
| 107917 | 1 | 0.2% |
| n'428915 | 1 | 0.2% |
| 117915 | 1 | 0.2% |
| 124915 | 1 | 0.2% |
| 125920 | 1 | 0.2% |
| n'433915 | 1 | 0.2% |
| Other values (394) | 394 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 471 | |
| 9 | 459 | |
| 2 | 292 | |
| 4 | 269 | |
| 5 | 231 | |
| ' | 228 | |
| 0 | 197 | |
| 7 | 188 | 6.7% |
| 3 | 140 | 5.0% |
| N | 119 | 4.2% |
| Other values (17) | 214 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2808 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 471 | |
| 9 | 459 | |
| 2 | 292 | |
| 4 | 269 | |
| 5 | 231 | |
| ' | 228 | |
| 0 | 197 | |
| 7 | 188 | 6.7% |
| 3 | 140 | 5.0% |
| N | 119 | 4.2% |
| Other values (17) | 214 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2808 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 471 | |
| 9 | 459 | |
| 2 | 292 | |
| 4 | 269 | |
| 5 | 231 | |
| ' | 228 | |
| 0 | 197 | |
| 7 | 188 | 6.7% |
| 3 | 140 | 5.0% |
| N | 119 | 4.2% |
| Other values (17) | 214 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2808 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 471 | |
| 9 | 459 | |
| 2 | 292 | |
| 4 | 269 | |
| 5 | 231 | |
| ' | 228 | |
| 0 | 197 | |
| 7 | 188 | 6.7% |
| 3 | 140 | 5.0% |
| N | 119 | 4.2% |
| Other values (17) | 214 |
CIN_IS_ACTV
Boolean
High correlation Missing
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 166 |
| Missing (%) | 32.7% |
| Memory size | 4.1 KiB |
| True | |
|---|---|
| False | |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 251 | |
| False | 90 | 17.8% |
| (Missing) | 166 |
CIN_IS_DEL
Boolean
Constant Missing
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 166 |
| Missing (%) | 32.7% |
| Memory size | 4.1 KiB |
| False | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| False | 341 | |
| (Missing) | 166 |
CIN_LIC_ISSUE_DATE
Unsupported
Missing Rejected Unsupported
| Missing | 507 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 4.1 KiB |
CIN_LIC_NO
Unsupported
Missing Rejected Unsupported
| Missing | 507 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 4.1 KiB |
CIN_NAME_SHORT
Text
Missing
| Distinct | 279 |
|---|---|
| Distinct (%) | 99.6% |
| Missing | 227 |
| Missing (%) | 44.8% |
| Memory size | 4.1 KiB |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 7.875 |
| Min length | 6 |
Unique
| Unique | 278 ? |
|---|---|
| Unique (%) | 99.3% |
Sample
| 1st row | STATET |
|---|---|
| 2nd row | GEORGE BS |
| 3rd row | PMATTA GC |
| 4th row | NEWCAS |
| 5th row | HORNSB |
| Value | Count | Frequency (%) |
| ct | 56 | 12.3% |
| vm | 46 | 10.1% |
| gc | 27 | 5.9% |
| bs | 12 | 2.6% |
| george | 8 | 1.8% |
| cherms | 8 | 1.8% |
| inaloo | 8 | 1.8% |
| macart | 7 | 1.5% |
| loganh | 7 | 1.5% |
| pacfar | 7 | 1.5% |
| Other values (111) | 269 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 197 | 8.9% |
| 175 | 7.9% | |
| C | 172 | 7.8% |
| T | 165 | 7.5% |
| R | 149 | 6.8% |
| N | 145 | 6.6% |
| M | 143 | 6.5% |
| O | 132 | 6.0% |
| E | 105 | 4.8% |
| S | 102 | 4.6% |
| Other values (17) | 720 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2205 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 197 | 8.9% |
| 175 | 7.9% | |
| C | 172 | 7.8% |
| T | 165 | 7.5% |
| R | 149 | 6.8% |
| N | 145 | 6.6% |
| M | 143 | 6.5% |
| O | 132 | 6.0% |
| E | 105 | 4.8% |
| S | 102 | 4.6% |
| Other values (17) | 720 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2205 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 197 | 8.9% |
| 175 | 7.9% | |
| C | 172 | 7.8% |
| T | 165 | 7.5% |
| R | 149 | 6.8% |
| N | 145 | 6.6% |
| M | 143 | 6.5% |
| O | 132 | 6.0% |
| E | 105 | 4.8% |
| S | 102 | 4.6% |
| Other values (17) | 720 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2205 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 197 | 8.9% |
| 175 | 7.9% | |
| C | 172 | 7.8% |
| T | 165 | 7.5% |
| R | 149 | 6.8% |
| N | 145 | 6.6% |
| M | 143 | 6.5% |
| O | 132 | 6.0% |
| E | 105 | 4.8% |
| S | 102 | 4.6% |
| Other values (17) | 720 |
TIMESTAMP
Text
Unique
| Distinct | 507 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 KiB |
Length
| Max length | 18 |
|---|---|
| Median length | 18 |
| Mean length | 18 |
| Min length | 18 |
Unique
| Unique | 507 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 0x00000007A0BFE21A |
|---|---|
| 2nd row | 0x00000007A0031758 |
| 3rd row | 0x0000000779D05A91 |
| 4th row | 0x0000000629B9F537 |
| 5th row | 0x00000006DAF9F47E |
| Value | Count | Frequency (%) |
| 0x00000007a0bfe21a | 1 | 0.2% |
| 0x00000007a0031758 | 1 | 0.2% |
| 0x0000000779d05a91 | 1 | 0.2% |
| 0x0000000629b9f537 | 1 | 0.2% |
| 0x00000006daf9f47e | 1 | 0.2% |
| 0x00000007f7c5db84 | 1 | 0.2% |
| 0x0000000779d05a98 | 1 | 0.2% |
| 0x00000006156d9b95 | 1 | 0.2% |
| 0x00000006156d9b9a | 1 | 0.2% |
| 0x0000000779d05a9a | 1 | 0.2% |
| Other values (497) | 497 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4396 | |
| 7 | 577 | 6.3% |
| x | 507 | 5.6% |
| 6 | 502 | 5.5% |
| D | 465 | 5.1% |
| 1 | 348 | 3.8% |
| 5 | 314 | 3.4% |
| B | 290 | 3.2% |
| 9 | 285 | 3.1% |
| F | 280 | 3.1% |
| Other values (7) | 1162 | 12.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 9126 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 4396 | |
| 7 | 577 | 6.3% |
| x | 507 | 5.6% |
| 6 | 502 | 5.5% |
| D | 465 | 5.1% |
| 1 | 348 | 3.8% |
| 5 | 314 | 3.4% |
| B | 290 | 3.2% |
| 9 | 285 | 3.1% |
| F | 280 | 3.1% |
| Other values (7) | 1162 | 12.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 9126 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 4396 | |
| 7 | 577 | 6.3% |
| x | 507 | 5.6% |
| 6 | 502 | 5.5% |
| D | 465 | 5.1% |
| 1 | 348 | 3.8% |
| 5 | 314 | 3.4% |
| B | 290 | 3.2% |
| 9 | 285 | 3.1% |
| F | 280 | 3.1% |
| Other values (7) | 1162 | 12.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 9126 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 4396 | |
| 7 | 577 | 6.3% |
| x | 507 | 5.6% |
| 6 | 502 | 5.5% |
| D | 465 | 5.1% |
| 1 | 348 | 3.8% |
| 5 | 314 | 3.4% |
| B | 290 | 3.2% |
| 9 | 285 | 3.1% |
| F | 280 | 3.1% |
| Other values (7) | 1162 | 12.7% |
Interactions
Correlations
| CCT_ID | CIN_ACCT_CODE | CIN_GL_CODE | CIN_GST_CODE | CIN_ID | CIN_IS_ACTV | CIN_STATUS_CODE | CIN_TYPE_ID | SITE_ID | SRC_DB_ID | SRC_TYPE_ID | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| CCT_ID | 1.000 | 0.597 | 0.502 | 0.303 | 0.000 | 0.000 | 0.000 | 0.063 | 0.000 | 1.000 | 1.000 |
| CIN_ACCT_CODE | 0.597 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.102 | 0.183 | 1.000 | 1.000 |
| CIN_GL_CODE | 0.502 | 0.000 | 1.000 | 0.000 | 0.320 | 0.313 | 0.313 | 0.582 | -0.071 | NaN | 1.000 |
| CIN_GST_CODE | 0.303 | 0.000 | 0.000 | 1.000 | 0.034 | 0.130 | 0.130 | 0.000 | 0.138 | 1.000 | 1.000 |
| CIN_ID | 0.000 | 0.000 | 0.320 | 0.034 | 1.000 | 0.176 | 0.034 | 0.129 | 0.214 | 0.629 | 0.703 |
| CIN_IS_ACTV | 0.000 | 0.000 | 0.313 | 0.130 | 0.176 | 1.000 | 0.981 | 0.000 | 0.000 | 1.000 | 0.770 |
| CIN_STATUS_CODE | 0.000 | 0.000 | 0.313 | 0.130 | 0.034 | 0.981 | 1.000 | 0.000 | 0.000 | 1.000 | 1.000 |
| CIN_TYPE_ID | 0.063 | 0.102 | 0.582 | 0.000 | 0.129 | 0.000 | 0.000 | 1.000 | -0.044 | NaN | 1.000 |
| SITE_ID | 0.000 | 0.183 | -0.071 | 0.138 | 0.214 | 0.000 | 0.000 | -0.044 | 1.000 | NaN | 1.000 |
| SRC_DB_ID | 1.000 | 1.000 | NaN | 1.000 | 0.629 | 1.000 | 1.000 | NaN | NaN | 1.000 | 0.505 |
| SRC_TYPE_ID | 1.000 | 1.000 | 1.000 | 1.000 | 0.703 | 0.770 | 1.000 | 1.000 | 1.000 | 0.505 | 1.000 |
Missing values
Sample
| HEAD_OFFICE_ID | REC_TYPE | SRC_DB_ID | SRC_TYPE_ID | CIN_ID | CIN_EXT_SALES_ID | CIN_GRP_ID | CIN_STATUS_CODE | CIN_TYPE_ID | CCT_ID | CRNCY_ID | SITE_ID | CINEMA | CIN_ACCT_CODE | CIN_CODE | CIN_CRNCY | CIN_CRCY_REG | CIN_EMAIL | CIN_GL_CODE | CIN_GRP_CODE | CIN_GST_CODE | CIN_HO_CODE | CIN_IS_ACTV | CIN_IS_DEL | CIN_LIC_ISSUE_DATE | CIN_LIC_NO | CIN_NAME_SHORT | TIMESTAMP | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2 | None | 4 | 1 | 3 | NaN | A | 1.0 | 1180.0 | 1.0 | 96.0 | State Theatre | 102370 | 1 | None | 370 | None | ABN: | 102370 | True | False | None | None | STATET | 0x00000007A0BFE21A | |||
| 1 | 2 | None | 4 | 1 | 7 | NaN | A | 10.0 | 177.0 | 1.0 | 14.0 | George Street Cafe Bar | 104918 | 1 | 919 | None | ABN: 99 000 024 439 | 104918 | True | False | None | None | GEORGE BS | 0x00000007A0031758 | ||||
| 2 | 2 | None | 4 | 1 | 11 | NaN | A | 7.0 | 177.0 | 1.0 | 58.0 | Parramatta Gold Class | 107917 | 1 | 917 | None | ABN: 33 595 052 153 | 107917 | True | False | None | None | PMATTA GC | 0x0000000779D05A91 | ||||
| 3 | 2 | None | 4 | 1 | 15 | NaN | I | 1.0 | 177.0 | 1.0 | 91.0 | zInactive-Newcastle | 111915 | 1 | 915 | None | ABN: 99 000 024 439 | 111915 | False | False | None | None | NEWCAS | 0x0000000629B9F537 | ||||
| 4 | 2 | None | 4 | 1 | 19 | NaN | A | 1.0 | 177.0 | 1.0 | 18.0 | Hornsby | 117915 | 1 | 915 | None | ABN: 11 913 370 633 | 117915 | True | False | None | None | HORNSB | 0x00000006DAF9F47E | ||||
| 5 | 2 | None | 4 | 1 | 23 | NaN | A | 1.0 | 177.0 | 1.0 | 53.0 | Blacktown | 124915 | 1 | 915 | None | ABN: 99 000 024 439 | 124915 | True | False | None | None | BLKTWN | 0x00000007F7C5DB84 | ||||
| 6 | 2 | None | 4 | 1 | 27 | NaN | A | 11.0 | 177.0 | 1.0 | 89.0 | Kotara Vmax | 125920 | 1 | None | 918 | None | ABN: 99 000 024 439 | 125920 | True | False | None | None | KOTARA VM | 0x0000000779D05A98 | |||
| 7 | 2 | None | 4 | 1 | 31 | NaN | A | 7.0 | 177.0 | 1.0 | 11.0 | Bondi Junction Gold Class | 132917 | 1 | 917 | None | ABN: 33 595 052 153 | 132917 | True | False | None | None | BONDIJ GC | 0x00000006156D9B95 | ||||
| 8 | 2 | None | 4 | 1 | 35 | NaN | A | 7.0 | 177.0 | 1.0 | 21.0 | Castle Hill Gold Class | 133917 | 1 | 917 | None | ABN: 25 221 284 744 | 133917 | True | False | None | None | CASTLE GC | 0x00000006156D9B9A | ||||
| 9 | 2 | None | 4 | 1 | 39 | NaN | A | 11.0 | 177.0 | 1.0 | 19.0 | Burwood Vmax | 134920 | 1 | 918 | None | ABN: 11 913 370 633 | 134920 | True | False | None | None | BURWOD VM | 0x0000000779D05A9A |
| HEAD_OFFICE_ID | REC_TYPE | SRC_DB_ID | SRC_TYPE_ID | CIN_ID | CIN_EXT_SALES_ID | CIN_GRP_ID | CIN_STATUS_CODE | CIN_TYPE_ID | CCT_ID | CRNCY_ID | SITE_ID | CINEMA | CIN_ACCT_CODE | CIN_CODE | CIN_CRNCY | CIN_CRCY_REG | CIN_EMAIL | CIN_GL_CODE | CIN_GRP_CODE | CIN_GST_CODE | CIN_HO_CODE | CIN_IS_ACTV | CIN_IS_DEL | CIN_LIC_ISSUE_DATE | CIN_LIC_NO | CIN_NAME_SHORT | TIMESTAMP | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 497 | 2 | U | 38 | 2 | 10760 | None | NaN | None | NaN | NaN | NaN | NaN | None | None | None | None | None | None | None | None | None | None | None | None | None | None | None | 0x000000051251CE85 |
| 498 | 2 | None | 4 | 1 | 10764 | NaN | A | 6.0 | 177.0 | 1.0 | 7307.0 | Ed Square Delivery | 127922 | 1 | None | 922 | None | ABN: | 127922 | True | False | None | None | EDPARK CT | 0x0000000779D05B23 | |||
| 499 | 2 | None | 4 | 1 | 10768 | NaN | A | 6.0 | 177.0 | 1.0 | 97.0 | Palmerston Delivery | 483922 | 1 | None | 922 | None | ABN: 33 595 052 153 | 483922 | True | False | None | None | PALMNT CT | 0x0000000779D05B25 | |||
| 500 | 2 | None | 4 | 1 | 10772 | NaN | A | 11.0 | 178.0 | 1.0 | 75.0 | Queensgate Vmax | 719918 | 719920 | 1 | None | 918 | None | ABN: | 719920 | True | False | None | None | QSGATE VM | 0x0000000779D05B29 | ||
| 501 | 2 | None | 4 | 1 | 10776 | NaN | A | 13.0 | 177.0 | 1.0 | 40.0 | Strathpine Recline | 470924 | 1 | None | 924 | None | ABN: 75 934 743 451 | 470924 | True | False | None | None | STRPNE RC | 0x0000000779D05B2C | |||
| 502 | 2 | None | 4 | 1 | 10780 | NaN | A | 14.0 | 177.0 | 1.0 | 23.0 | Robina SCREENX | 407926 | 1 | None | 926 | None | ABN: 40 009 659 643 | 407926 | True | False | None | None | ROBINA SX | 0x00000007D82F1BC3 | |||
| 503 | 2 | None | 4 | 1 | 10785 | NaN | A | 10.0 | 177.0 | 1.0 | 7317.0 | IMAX Sydney Cafe Bar | 120918 | 1 | None | 919 | None | ABN: | 120918 | True | False | None | None | IMAXSY BS | 0x0000000779D05B2F | |||
| 504 | 2 | None | 4 | 1 | 10791 | NaN | A | 3.0 | 177.0 | 1.0 | 22.0 | Pacific Fair IMAX | 405923 | 405923 | 1 | None | 923 | None | ABN: 40 009 659 643 | 405923 | True | False | None | None | PACFAR IM | 0x00000007D810F1C1 | ||
| 505 | 2 | None | 4 | 1 | 10797 | NaN | A | 13.0 | 177.0 | 1.0 | 29.0 | Rockhampton Recline | 426924 | 1 | None | 924 | None | ABN: 40 009 659 643 | 426924 | True | False | None | None | ROCNTH RC | 0x0000000779D05B33 | |||
| 506 | 2 | None | 4 | 1 | 10801 | NaN | A | 14.0 | 177.0 | 1.0 | 59.0 | Loganholme SCREENX | 450926 | 1 | None | 926 | None | ABN: 130 80111 173 | 450926 | True | False | None | None | LOGANH SX | 0x00000007D82F1BC6 |